﻿

CREATE VIEW [dbo].[RaportareFoiBoalaASS]
AS
SELECT     dbo.Persoane.NumePrenume, dbo.Persoane.Cnp, dbo.RaportareFoiBoala.MedicPrescriptor, dbo.RaportareFoiBoala.UnitateaSanitaraMedic, 
                      dbo.RaportareFoiBoala.DataUpdate, dbo.RaportareFoiBoala.DataAnuntare
FROM         dbo.RaportareFoiBoala INNER JOIN
                      dbo.Persoane ON dbo.RaportareFoiBoala.IDPersoana = dbo.Persoane.IdPersoana